Stored Procedures [dbo].[BAEGetFieldsToUse]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEGetFieldsToUse
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Categoryvarchar(50)50
SQL Script
create procedure [dbo].[BAEGetFieldsToUse] @Category varchar(50) as
SELECT Variable, CurrentValue
    FROM Configuration
    WHERE Category = @Category AND Variable LIKE 'FieldToUse%'

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved